<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreatePrtSysConfTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('prt_sys_conf', function (Blueprint $table) {
            $table->increments('id');
            $table->string('sys_name',100)->default("")->comment('系统名称');
            $table->tinyInteger('themes')->default(1)->comment('风格设置');
            $table->integer('page_limit')->default(0)->comment("每页显示")->nullable();
            $table->string('page_list',100)->default("")->comment("分页列表")->nullable();
            $table->string('money_flag',100)->default("")->comment("货币标识")->nullable();
            $table->tinyInteger('money_decimal')->default(0)->comment("金额保留小数")->nullable();
            $table->tinyInteger('is_open_captcha')->default(0)->comment("开启验证码")->nullable();
            $table->string('copyright',100)->default("")->comment("版权信息")->nullable();
            $table->string('ipc',100)->default("")->comment("备案号")->nullable();
            $table->tinyInteger('is_tips')->default(1)->comment("操作提示")->nullable();
            $table->tinyInteger('sort')->default(1)->comment("权重")->nullable();

            $table->tinyInteger('status')->default(1)->comment('启用状态');
            $table->tinyInteger('check_status')->default(1)->comment('审核状态');
            $table->integer('creator_uid')->default(0)->comment("创建人")->nullable();
            $table->integer('updater_uid')->default(0)->comment("修改人")->nullable();
            $table->integer('created_at')->comment("创建时间")->nullable();
            $table->integer('updated_at')->comment("更新时间")->nullable();
            $table->integer('deleted_at')->default(null)->comment("删除时间")->nullable();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('prt_sys_conf');
    }
}
